﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace QunYing.DAL
{
	/// <summary>
	/// 数据访问类:VipServices
	/// </summary>
	public partial class VipServices
	{
        /// <summary>
        /// 查询服务条款
        /// </summary>
        /// <param name="grade"></param>
        /// <returns></returns>
        public DataTable getService(string grade)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from [dbo].[V_Service] where 等级名称=@等级名称");
            SqlParameter[] parames = { 
                                     new SqlParameter("@等级名称",grade)
            };
            return DbHelperSQL.Query(strSql.ToString(), parames).Tables[0];
        }
	}
}

